Hello Everybody
In our MAXDB Database 7.6 we don’t allow NULL values.
So every column in a table is defined with
yyy char(n) ascii NOT NULL Default ’ ’
xxx fixed(n,n) NOT NULL Default 0.0
zzz datetime not null Default ‘9999-12-31 00:00:00.0000’
When i look into my Servoy table definition each field is check with ALLOW NULL , except the primary key ???
Is this OK ???
Sometimes i get some errors:
save failed for 1 or more records
com.servoy.j2db.dataprocessing.DataException: [-5005] (at 109): Missing non-NULL value
Best regards
Albert
Albert,
It seems that the driver does not report all column info correctly to Servoy.
Are you using the latest driver?
Rob
Hello Rob
I found the problem and ran into another one.
For our produktion database i need an older jdbc driver !!
I copied it into the drivers directory and everything seems ok, the field definitions show allow null unchecked.
But now i can’t connect to our test database (newer version).
In my drivers directory i have 2 drivers for maxdb now.
sapdbc.jar (the old one for our produktion database which seems to work now)
newsapdbc.jar (the newer one needed for our test database)
But now i can’t configure our testdatabase!!
In the drivers list there is only one entry for SAPDBC(com.sap.dbtech.jdbc.DriverSapDB) ?? (the older one, i think)
So i have a working connection to produktion and no connection to test ???
Any idear, how to configure the test database with the newer driver, how to get 2 different SAP drivers into the list ???
Best regards
Albert
Albert,
You cannot have the same driver class in multiple jars.
One of them will get picked up, the other one gets ignored.
The only way to connect to 2 database with the same driver class but a different driver jar is to use 2 server/developer instances.
Rob