PDA

View Full Version : Unsupported databases



JGunderson
01-25-2006, 12:24 PM
Hi,
I tried to define a new JDBC driver for a database not on the supported list. I defined it as a generic database and entered the URL and driver class. I also update the spoon.bat so that the jar containing driver is defined in the CLASSPATH. I tested with the explore function and it works fine.


I then used the new connection in a Table Input. The preview functions works fine. The Transformation:verify function says all is OK. But when I run the transformation I get:



Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
ODBC Driver Manager[img]/wiki/images/newpage.gif ("]Microsoft[img]/wiki/images/newpage.gif[/url][/url][url=")[/url] Data source name not found and no default driver specified



Any hints would be appreciated.



Thx, Jeff

MattCasters
01-25-2006, 10:10 PM
Hi Jeff,


This is typically an error you get when the meta-data is OK in memory (preview) but is not loaded correctly from XML or from the repository (run).
I'll look into this and fix it in 2.2.2-dev.



Thanks for the report!



Kind regards,



Matt

JGunderson
02-08-2006, 01:35 PM
Hi Matt,
If OK, I will write a bug report and we will try to come up with a fix.
Jeff

MattCasters
02-08-2006, 01:38 PM
Can you add the XML from the database connection? (right click on connection : copy to clipboard)
That way we can perhaps already see what's missing.
Thanks!
Matt

kettle_jgrengbondai
02-09-2006, 06:10 AM
Here is the XML from the database connection followed by the error log. The transformation is using ODBC instead of the native jdbc as specified in the connection.

<?xml version="1.0" encoding="UTF-8"?>
<connection>
<name>TIGER</name>
<server></server>
<type>GENERIC</type>
<access>Native</access>
<database></database>
<port>0</port>
<username>Public</username>
<password>Encrypted </password>
<servername></servername>
<data_tablespace></data_tablespace>
<index_tablespace></index_tablespace>
<attributes>
<attribute><code>CUSTOM_DRIVER_CLASS</code><attribute>ordbjava.jdbc.ordbDriver</attribute></attribute>
<attribute><code>CUSTOM_URL</code><attribute>jdbc:cincomtiger:demodb</attribute></attribute>
<attribute><code>SAPClient</code><attribute></attribute></attribute>
<attribute><code>SAPLanguage</code><attribute></attribute></attribute>
<attribute><code>SAPSystemNumber</code><attribute></attribute></attribute>
</attributes>
</connection>

----------------------------------------

ERROR Message:

2006/02/09 09:57:44 - Spoon - Clicked on TIGER
2006/02/09 09:57:46 - Spoon - (EDIT) Element has parent.
2006/02/09 09:58:04 - Spoon - Save to file or repository...
2006/02/09 09:58:04 - Spoon - File written to [E:\warehouse\kettleSrc22\mykettle22.ktr]
2006/02/09 09:58:04 - DBCache - We wrote 0 cached rows to the database cache!
2006/02/09 09:58:12 - be.ibridge.kettle.trans.TransMeta - We have 1 connections...
2006/02/09 09:58:12 - be.ibridge.kettle.trans.TransMeta - Looking at connection #0
2006/02/09 09:58:12 - be.ibridge.kettle.trans.TransMeta - Reading 1 steps...
2006/02/09 09:58:12 - be.ibridge.kettle.trans.TransMeta - Looking at step #0
2006/02/09 09:58:12 - StepMeta() - looking for the right step node (Table input)
2006/02/09 09:58:12 - StepMeta() - specifics loaded for Table input
2006/02/09 09:58:12 - StepMeta() - end of readXML()
2006/02/09 09:58:12 - be.ibridge.kettle.trans.TransMeta - We have 0 hops...
2006/02/09 09:58:12 - be.ibridge.kettle.trans.TransMeta - nr of steps read : 1
2006/02/09 09:58:12 - be.ibridge.kettle.trans.TransMeta - nr of hops read : 0
2006/02/09 09:58:12 - Spoon - Transformation opened.
2006/02/09 09:58:12 - Spoon - Excecuting transformation [null]...
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Dispatching started for filename [E:\warehouse\kettleSrc22\mykettle22.ktr]
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Nr of arguments detected: 10
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - I found 1 different steps to launch.
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Allocating rowsets...
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Allocating rowsets for step 0 --> Table input
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Allocated 0 rowsets for step 0 --> Table input
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Allocating Steps & StepData...
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Transformation is about to allocate step [Table input] of type [TableInput]
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Step has nrcopies=1
2006/02/09 09:58:12 - Table input.0 - distribution activated
2006/02/09 09:58:12 - Table input.0 - Starting allocation of buffers & new threads...
2006/02/09 09:58:12 - Table input.0 - Step info: nrinput=0 nroutput=0
2006/02/09 09:58:12 - Table input.0 - Finished dispatching
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - Transformation has allocated a new step: [Table input].0
2006/02/09 09:58:12 - TIGER - New database connection defined
2006/02/09 09:58:12 - Table input.0 - ERROR : An error occurred, processing will be stopped:
Error occured while trying to connect to the database

Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - ERROR : Error initializing step [Table input]
2006/02/09 09:58:12 - be.ibridge.kettle.trans.Trans - ERROR : We failed to initialize at least one step. Execution can not begin!
2006/02/09 09:58:12 - Spoon - Started.
2006/02/09 09:58:12 - Spoon - The transformation has finished!!


Thanks,
Jules

kettle_wconroy
03-28-2006, 05:24 AM
I am encountering this same error. the problem is line 827 in DatabaseMeta. It does not respect the access type from the XML file if the database type is generic.

The comment says that it is in there for backwards compatability, but can that blind setting of the access type be changed?

--Bo

MattCasters
03-28-2006, 05:31 AM
Yeah, in the yeah-old-days (when animals could still talk) the format was slightly different, that&#39;s why the comment is in there. I&#39;ll remove the whole block later tonight. I don&#39;t know anyone of the older customers that is still on the 1.x tree anyway.

Thanks for finding it. I got so busy that I somehow never got round to this one :-(

Matt

kettle_wconroy
03-28-2006, 05:35 AM
Thanks for the quick response.

I would assume that the code i should be looking at is the 2.2.2 branch, is that correct? or are the nightly builds going from the trunk?

Should I download the 2.3.0 version in order to use the nightly builds?

Thanks again.

Bo

MattCasters
03-28-2006, 05:42 AM
The build system of Javaforge is broken at the moment. They are upgrading the OS and DB and hopefully also the forum software. (don&#39;t you just hate that project list on the left?)
Anyway, at the moment, the safest to go is do a subversion checkout/update from http://svn.javaforge.com/svn/Kettle/trunk/
Trunk is the 2.3.0 development tree and this is where all the action is:
- Localisation (i18n) of Spoon, Chef, .. into Simplified Chinese and later Spanish, Dutch, French, whatever
- Enhancements to text file input
- source-to-target mappings with new dialog (tracker 1569, http://www.javaforge.com/proj/tracker/itemDetails.do?task_id=1569&navigation=true)
- Lots of bugfixes, feature requests are already implemented.
- Too much to tell really, you should check the trackers.

I hope that the nightly builds will be back soon, because it&#39;s starting to bother a few people ...

All the best,
Matt