473,791 Members | 3,186 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

dynamic SQL from Hibernate and SQLCODE -301

I have a situation which I cannot get a good lead on how to resolve.
One of the applications I support uses the Hibernate software to
generate SQL. The app is JAVA with JDBC. In testing the users see no
problems and think the app is running okay. I turned a database
monitor on the app and see that the database is getting SQL return
coes of -301 for a variety of database accesses (some times the same
access works, okay other times -301). The SQLCODE points to a data
type problem. If anyone could point me in the right direction to
resolve this I would greatly appreciate it. The output from the
monitor is below:

62) Statement Event ...
Appl Handle: 196
Appl Id: 0AFD854B.FA73.0 41112193916
Appl Seq number: 0007

Record is the result of a flush: FALSE
-------------------------------------------
Type : Dynamic
Operation: Execute
Section : 9
Creator : NULLID
Package : SQLLF300
Consistency Token : hADcQaDP
Package Version ID :

Cursor : SQLCUR9
Cursor was blocking: FALSE
Text : update PW_PLWS_RO.CRED IT_RPT_REQ set RPT_ID=?, CO_ID=?,
CHOICE_PT_A
CCT_NUM=?, EFF_DT=?, FIRST_NM=?, LST_NM=?, MID_INIT_NM=?, SFX_NM=?,
STREET=?, CI
TY=?, STATE=?, ZIP=?, DOB_DT=?, SSN=?, STAT_CD=?, GATEWAY_RPT_ID= ?
where CREDIT_
REQ_ID=?
-------------------------------------------
Start Time: 11-12-2004 14:39:16.419955
Stop Time: 11-12-2004 14:39:16.420144
Exec Time: 0.000189 seconds
Number of Agents created: 1
User CPU: 0.000000 seconds
System CPU: 0.000000 seconds
Fetch Count: 0
Sorts: 0
Total sort time: 0
Sort overflows: 0
Rows read: 0
Rows written: 0
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Bufferpool data logical reads: 0
Bufferpool data physical reads: 0
Bufferpool temporary data logical reads: 0
Bufferpool temporary data physical reads: 0
Bufferpool index logical reads: 0
Bufferpool index physical reads: 0
Bufferpool temporary index logical reads: 0
Bufferpool temporary index physical reads: 0
SQLCA:
sqlcode: -301
sqlstate: 07006
Nov 12 '05 #1
3 9643
aj
Check your <entity>.hbm.xm l mapping file for
CREDIT_RPT_REQ. I think you have incorrectly
specified a column TYPE somewhere.

The line looks like:
property name="blahblah" TYPE="string" column="columnb lah"/>

I think the reason you sometimes see the error and sometimes
not is that in some cases the column w/ the bad TYPE is not
being updated, sometimes it is...

As an aside, and IMNSHO, Hibernate is kick-ass software..

Good luck.

aj
JDPope wrote:
I have a situation which I cannot get a good lead on how to resolve.
One of the applications I support uses the Hibernate software to
generate SQL. The app is JAVA with JDBC. In testing the users see no
problems and think the app is running okay. I turned a database
monitor on the app and see that the database is getting SQL return
coes of -301 for a variety of database accesses (some times the same
access works, okay other times -301). The SQLCODE points to a data
type problem. If anyone could point me in the right direction to
resolve this I would greatly appreciate it. The output from the
monitor is below:

62) Statement Event ...
Appl Handle: 196
Appl Id: 0AFD854B.FA73.0 41112193916
Appl Seq number: 0007

Record is the result of a flush: FALSE
-------------------------------------------
Type : Dynamic
Operation: Execute
Section : 9
Creator : NULLID
Package : SQLLF300
Consistency Token : hADcQaDP
Package Version ID :

Cursor : SQLCUR9
Cursor was blocking: FALSE
Text : update PW_PLWS_RO.CRED IT_RPT_REQ set RPT_ID=?, CO_ID=?,
CHOICE_PT_A
CCT_NUM=?, EFF_DT=?, FIRST_NM=?, LST_NM=?, MID_INIT_NM=?, SFX_NM=?,
STREET=?, CI
TY=?, STATE=?, ZIP=?, DOB_DT=?, SSN=?, STAT_CD=?, GATEWAY_RPT_ID= ?
where CREDIT_
REQ_ID=?
-------------------------------------------
Start Time: 11-12-2004 14:39:16.419955
Stop Time: 11-12-2004 14:39:16.420144
Exec Time: 0.000189 seconds
Number of Agents created: 1
User CPU: 0.000000 seconds
System CPU: 0.000000 seconds
Fetch Count: 0
Sorts: 0
Total sort time: 0
Sort overflows: 0
Rows read: 0
Rows written: 0
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Bufferpool data logical reads: 0
Bufferpool data physical reads: 0
Bufferpool temporary data logical reads: 0
Bufferpool temporary data physical reads: 0
Bufferpool index logical reads: 0
Bufferpool index physical reads: 0
Bufferpool temporary index logical reads: 0
Bufferpool temporary index physical reads: 0
SQLCA:
sqlcode: -301
sqlstate: 07006

Nov 12 '05 #2
Actually a few monitor events and thousands of a second later the
exact same statement gets a zero SQL return code, as shown below. The
events in between are:
63) COMMIT SQLCODE 0 Appl Seq number 0007
64) COMPLETION Appl Seq Number 0007
65) DESCRIBE of the this SQL code Appl Seq number 0008

Is hibernate correcting itself or what is really happening here. As I
said before the update on the database takes place but why the first
-301?

Thanks for taking time with this. It seems like it could be a common
problem that no one has discussed much and may not be a real problem
but a bad return code is a bad return code.
*************** ******* MONITOR OUTPUT *************** ******
66) Statement Event ...
Appl Handle: 196
Appl Id: 0AFD854B.FA73.0 41112193916
Appl Seq number: 0008

Record is the result of a flush: FALSE
-------------------------------------------
Type : Dynamic
Operation: Execute
Section : 9
Creator : NULLID
Package : SQLLF300
Consistency Token : hADcQaDP
Package Version ID :

Cursor : SQLCUR9
Cursor was blocking: FALSE
Text : update PW_PLWS_RO.CRED IT_RPT_REQ set RPT_ID=?, CO_ID=?,
CHOICE_PT_A
CCT_NUM=?, EFF_DT=?, FIRST_NM=?, LST_NM=?, MID_INIT_NM=?, SFX_NM=?,
STREET=?, CI
TY=?, STATE=?, ZIP=?, DOB_DT=?, SSN=?, STAT_CD=?, GATEWAY_RPT_ID= ?
where CREDIT_
REQ_ID=?
-------------------------------------------
Start Time: 11-12-2004 14:39:16.426059
Stop Time: 11-12-2004 14:39:16.426637
Exec Time: 0.000578 seconds
Number of Agents created: 1
User CPU: 0.000000 seconds
System CPU: 0.000000 seconds
Fetch Count: 0
Sorts: 0
Total sort time: 0
Sort overflows: 0
Rows read: 1
Rows written: 1
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Bufferpool data logical reads: 2
Bufferpool data physical reads: 0
Bufferpool temporary data logical reads: 0
Bufferpool temporary data physical reads: 0
Bufferpool index logical reads: 2
Bufferpool index physical reads: 0
Bufferpool temporary index logical reads: 0
Bufferpool temporary index physical reads: 0
SQLCA:
sqlcode: 0
sqlstate: 00000
aj <ro****@mcdonal ds.com> wrote in message news:<10******* ******@news.sup ernews.com>...
Check your <entity>.hbm.xm l mapping file for
CREDIT_RPT_REQ. I think you have incorrectly
specified a column TYPE somewhere.

The line looks like:
property name="blahblah" TYPE="string" column="columnb lah"/>

I think the reason you sometimes see the error and sometimes
not is that in some cases the column w/ the bad TYPE is not
being updated, sometimes it is...

As an aside, and IMNSHO, Hibernate is kick-ass software..

Good luck.

aj
JDPope wrote:
I have a situation which I cannot get a good lead on how to resolve.
One of the applications I support uses the Hibernate software to
generate SQL. The app is JAVA with JDBC. In testing the users see no
problems and think the app is running okay. I turned a database
monitor on the app and see that the database is getting SQL return
coes of -301 for a variety of database accesses (some times the same
access works, okay other times -301). The SQLCODE points to a data
type problem. If anyone could point me in the right direction to
resolve this I would greatly appreciate it. The output from the
monitor is below:

62) Statement Event ...
Appl Handle: 196
Appl Id: 0AFD854B.FA73.0 41112193916
Appl Seq number: 0007

Record is the result of a flush: FALSE
-------------------------------------------
Type : Dynamic
Operation: Execute
Section : 9
Creator : NULLID
Package : SQLLF300
Consistency Token : hADcQaDP
Package Version ID :

Cursor : SQLCUR9
Cursor was blocking: FALSE
Text : update PW_PLWS_RO.CRED IT_RPT_REQ set RPT_ID=?, CO_ID=?,
CHOICE_PT_A
CCT_NUM=?, EFF_DT=?, FIRST_NM=?, LST_NM=?, MID_INIT_NM=?, SFX_NM=?,
STREET=?, CI
TY=?, STATE=?, ZIP=?, DOB_DT=?, SSN=?, STAT_CD=?, GATEWAY_RPT_ID= ?
where CREDIT_
REQ_ID=?
-------------------------------------------
Start Time: 11-12-2004 14:39:16.419955
Stop Time: 11-12-2004 14:39:16.420144
Exec Time: 0.000189 seconds
Number of Agents created: 1
User CPU: 0.000000 seconds
System CPU: 0.000000 seconds
Fetch Count: 0
Sorts: 0
Total sort time: 0
Sort overflows: 0
Rows read: 0
Rows written: 0
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Bufferpool data logical reads: 0
Bufferpool data physical reads: 0
Bufferpool temporary data logical reads: 0
Bufferpool temporary data physical reads: 0
Bufferpool index logical reads: 0
Bufferpool index physical reads: 0
Bufferpool temporary index logical reads: 0
Bufferpool temporary index physical reads: 0
SQLCA:
sqlcode: -301
sqlstate: 07006

Nov 12 '05 #3
This actually turned out to be a JDBC driver problem. Text concerning
this is below:
DB2 Topics
|Deferred Prepares with the Universal JDBC Driver
|You can use the deferPrepares connection property as a |performance
directive
to affect the internal semantics of the input data type |conversion
capability
of the driver. By default the univeral JDBC |driver defers internal
prepare
requests (that is, the |java.sql.Conne ction.prepareSt atement()),
|until the
statement is executed (that is,
|java.sql.Prepa redStatement.ex ecute()).
||If enabled, the internal server prepare requests are deferred until
|execute
time. This allows the prepare and execute requests to be sent |as a
single
request to the server, which reduces network delays for both type |2
and type 4
connectivity. The deferred prepare means that the driver |works
without the
benefit of described parameters or result set metadata until
|execution time:
undescribed input data is sent as is to the |server, without any data
type
cross-conversion of the input data.
|Support for cross-conversion of the input data types is a JDBC
extension |that
does not require such support, but is supported by the universal JDBC
|driver.
Therefore, if statement execution fails when |deferPrepares is
enabled, the
driver tries the execution again with |described input. The statement
retry
logic is internal to the driver, |and is invisible to the application.
However,
if an application enables |deferPrepares, the input data types should
match the
database |column types as required by the JDBC specification. For
example, if
|deferPrepares is enabled, setter calls such as
|PreparedStatem ent.setShort()
should match the type |of the underlying column type (for example,
SMALLINT) for
optimal |performance. If deferPrepares is disabled, the driver
|requests
describe information at prepare time. Therefore, |the driver has
described input
parameter metadata available, and the |cross-conversion of input data
types is
supported for all |PreparedStatem ent setter methods without requiring
the
internal |statement retry logic.
|If the universal JDBC driver is performing deferred prepares without
the
|statement retry logic, setBytes() against a BLOB column |would yield
a -301
error. setObject() (with |Types.BLOB), setBinaryStream (), or
|setBlob() should
be used against BLOB columns when |deferPrepares is enabled to avoid
the
internal retry.
|The statement retry logic is not performed for batched executes.
|Therefore
input data types must match the described column types for all
|batched
parameters.
|It is not possible to flow BLOB data to LONG VARCHAR FOR BIT DATA.
|Therefore,
the setBinaryStream () method can only be |called against BLOB columns.
If the
target column is not a BLOB column, |the JCC client will receive a
-301 error.
No statement retry will be |attempted because the driver does not
perform
retries if any input parameter |is a stream. After an input stream has
been
exhausted it cannot be read |again, and it is impractical to fully
materialize
the input stream to retry |stream parameters. Statement retry logic is
not
performed when any |input parameter is a stream.
|If PreparedStateme nt.getMetaData( ) or |PreparedStatem ent.setObject()
is called
and no |target type is provided, a prepare will result.
jo*******@liber tymutual.com (JDPope) wrote in message news:<9d******* *************** ****@posting.go ogle.com>...
Actually a few monitor events and thousands of a second later the
exact same statement gets a zero SQL return code, as shown below. The
events in between are:
63) COMMIT SQLCODE 0 Appl Seq number 0007
64) COMPLETION Appl Seq Number 0007
65) DESCRIBE of the this SQL code Appl Seq number 0008

Is hibernate correcting itself or what is really happening here. As I
said before the update on the database takes place but why the first
-301?

Thanks for taking time with this. It seems like it could be a common
problem that no one has discussed much and may not be a real problem
but a bad return code is a bad return code.
*************** ******* MONITOR OUTPUT *************** ******
66) Statement Event ...
Appl Handle: 196
Appl Id: 0AFD854B.FA73.0 41112193916
Appl Seq number: 0008

Record is the result of a flush: FALSE
-------------------------------------------
Type : Dynamic
Operation: Execute
Section : 9
Creator : NULLID
Package : SQLLF300
Consistency Token : hADcQaDP
Package Version ID :

Cursor : SQLCUR9
Cursor was blocking: FALSE
Text : update PW_PLWS_RO.CRED IT_RPT_REQ set RPT_ID=?, CO_ID=?,
CHOICE_PT_A
CCT_NUM=?, EFF_DT=?, FIRST_NM=?, LST_NM=?, MID_INIT_NM=?, SFX_NM=?,
STREET=?, CI
TY=?, STATE=?, ZIP=?, DOB_DT=?, SSN=?, STAT_CD=?, GATEWAY_RPT_ID= ?
where CREDIT_
REQ_ID=?
-------------------------------------------
Start Time: 11-12-2004 14:39:16.426059
Stop Time: 11-12-2004 14:39:16.426637
Exec Time: 0.000578 seconds
Number of Agents created: 1
User CPU: 0.000000 seconds
System CPU: 0.000000 seconds
Fetch Count: 0
Sorts: 0
Total sort time: 0
Sort overflows: 0
Rows read: 1
Rows written: 1
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Bufferpool data logical reads: 2
Bufferpool data physical reads: 0
Bufferpool temporary data logical reads: 0
Bufferpool temporary data physical reads: 0
Bufferpool index logical reads: 2
Bufferpool index physical reads: 0
Bufferpool temporary index logical reads: 0
Bufferpool temporary index physical reads: 0
SQLCA:
sqlcode: 0
sqlstate: 00000
aj <ro****@mcdonal ds.com> wrote in message news:<10******* ******@news.sup ernews.com>...
Check your <entity>.hbm.xm l mapping file for
CREDIT_RPT_REQ. I think you have incorrectly
specified a column TYPE somewhere.

The line looks like:
property name="blahblah" TYPE="string" column="columnb lah"/>

I think the reason you sometimes see the error and sometimes
not is that in some cases the column w/ the bad TYPE is not
being updated, sometimes it is...

As an aside, and IMNSHO, Hibernate is kick-ass software..

Good luck.

aj
JDPope wrote:
I have a situation which I cannot get a good lead on how to resolve.
One of the applications I support uses the Hibernate software to
generate SQL. The app is JAVA with JDBC. In testing the users see no
problems and think the app is running okay. I turned a database
monitor on the app and see that the database is getting SQL return
coes of -301 for a variety of database accesses (some times the same
access works, okay other times -301). The SQLCODE points to a data
type problem. If anyone could point me in the right direction to
resolve this I would greatly appreciate it. The output from the
monitor is below:

62) Statement Event ...
Appl Handle: 196
Appl Id: 0AFD854B.FA73.0 41112193916
Appl Seq number: 0007

Record is the result of a flush: FALSE
-------------------------------------------
Type : Dynamic
Operation: Execute
Section : 9
Creator : NULLID
Package : SQLLF300
Consistency Token : hADcQaDP
Package Version ID :

Cursor : SQLCUR9
Cursor was blocking: FALSE
Text : update PW_PLWS_RO.CRED IT_RPT_REQ set RPT_ID=?, CO_ID=?,
CHOICE_PT_A
CCT_NUM=?, EFF_DT=?, FIRST_NM=?, LST_NM=?, MID_INIT_NM=?, SFX_NM=?,
STREET=?, CI
TY=?, STATE=?, ZIP=?, DOB_DT=?, SSN=?, STAT_CD=?, GATEWAY_RPT_ID= ?
where CREDIT_
REQ_ID=?
-------------------------------------------
Start Time: 11-12-2004 14:39:16.419955
Stop Time: 11-12-2004 14:39:16.420144
Exec Time: 0.000189 seconds
Number of Agents created: 1
User CPU: 0.000000 seconds
System CPU: 0.000000 seconds
Fetch Count: 0
Sorts: 0
Total sort time: 0
Sort overflows: 0
Rows read: 0
Rows written: 0
Internal rows deleted: 0
Internal rows updated: 0
Internal rows inserted: 0
Bufferpool data logical reads: 0
Bufferpool data physical reads: 0
Bufferpool temporary data logical reads: 0
Bufferpool temporary data physical reads: 0
Bufferpool index logical reads: 0
Bufferpool index physical reads: 0
Bufferpool temporary index logical reads: 0
Bufferpool temporary index physical reads: 0
SQLCA:
sqlcode: -301
sqlstate: 07006

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
34976
by: Todd Peterson | last post by:
I'm a newbie to DB2 and am trying to figure out how to write a stored procedure, using dynamic SQL statements to return a result set. I believe the majority of the hurdles I have been facing might be due to the fact that the samples and postings I have read have been related to the UDB... I believe our company is on some version of MVS or OS/390, but I am not sure which one, at the time of this posting. I have an example, below, of a...
2
2547
by: kofa | last post by:
Hi All, we're new to DB2 (using Express-C on Windows). We'd like to monitor the SQL that Hibernate (a Java ORM) generates, along with query params. It was quite simple to do so with MySQL, but we haven't found a way to do that with DB2. This is how far we got: create event monitor sqlmonitor for statements write to file 'f:\tmp\db2sql' set event monitor sqlmonitor state = 1
1
7120
by: AG | last post by:
After an upgrade to WebSphere/JDK environment (6.1/1.5) I am getting following error on Hibernate objects. Unfortunately, I was not able to find any info on ibm's web site about SQLCODE 4700. Everything works fine from my local machine. Trouble starts when we run it on z/OS. (We have LINUX on z/OS and we are running Java/ WebSpehere on it). DB2 SQL error: SQLCODE: -4700, SQLSTATE: 56038, SQLERRMC: null> DB2 SQL error: SQLCODE: -516,...
1
3571
by: chandukandula | last post by:
Hi Already my application in Struts using JDBC.At present my application is implemented in Struts with hibernate So i am not changing the SQL queries converting to the like this String sql4="select max(sed.SubexpenseId) from hiber.SubexpenseDet sed"; List query1 = session.createSQLQuery(sql4).addEntity(SubexpenseDet.class).list(); Iterator it1 = query1.iterator(); it1.hasNext(); SubexpenseDet set1 =...
6
1885
rsrinivasan
by: rsrinivasan | last post by:
Hi all, I am using Hibernate framework in my project. This is my configuration in my "hibernate.cfg.xml" file. <property name="hibernate.c3p0.max_size">25</property> <property name="hibernate.c3p0.min_size">3</property> <property name="hibernate.c3p0.timeout">5000</property> <!-- seconds --> <property name="hibernate.c3p0.max_statements">0</property> <property name="hibernate.c3p0.acquire_increment">3</property>...
3
3015
by: altafur | last post by:
hi, i am using java with hibernate . i want to run a hibernate order by query thru java. i have written the query in hibernate.hbm.xml file. the query is as follows: query: SELECT distinct a.process_id, a.name name, a.category_id,c.parent_id FROM tbl_process_master a, tbl_category c where (lower(a.name) like :searchString or lower(a.description) like :searchString or lower(a.meta_tag) like :searchString ) and a.status=:status and...
0
6522
by: neuraljay | last post by:
hi everyone. I am trying to build a jsp using webwork, hibernate and mysql. And right now I am doing its unit testing. Everytime I run the test I am getting this error: Error JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is...
1
4063
by: ashi1290 | last post by:
I am getting this error..... Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.hibernate.cfg.Configuration.<clinit>(Configuration.java:120) at com.author.hbn.HibernateUtil.<clinit>(HibernateUtil.java:12) at com.author.app.Abhi.main(Abhi.java:13) Configuration file looks like this <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration SYSTEM...
0
1438
by: Sirsuram | last post by:
Hi , I am facing problme with my code. it is not displaying the results of SELECT statement MOVE 'SELECT AAA, BBB FROM sample - ' WHERE AAA = 03 AND BBB = 86102104 - ' FETCH FIRST 1 ROW ONLY' TO QUERY-DATA DISPLAY "QUERY1: " QUERY-DATA EXEC SQL ...
2
5655
by: IuliaS | last post by:
Hello everyone! I want to create a stored procedure, so I can more easily, and transparent retrieve data from db2. Long story short: when a user wants to put some data in the DB, he also creates the tables and their links. When getting the data from the DB... well suffice to say it's ugly. I want to use one stored procedure that will return a result set as (name, value) pairs so I can display it nice and easy in the UI. So far I've managed to...
0
9669
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9517
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10428
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10156
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9997
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7537
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5435
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3718
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2916
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.