You are not logged in.
I Have to work with Pervasive Data, but got some problem with metadata connection.
Even if I add classpath in Talend' java build Path class still "not found" .
First Trying with a Talend job : first error come from Class jpscs.jar . Talend can't find it (even if put in Build path) .
Problem resolved with a tLibraryLoad.
But by this way I've to know the schema (and cannot do migration in a Sql Database "on the fly") !
Do a test with a metadata description and Generic JDBC metadata.
But never find the Driver class ! So no way to guess shema from Pervasive database.
How can I make JDBC metadata works with pervasive database ?
Seems that metadata JDBC didn't add classpath of the driver.
Talend Open Studio
Build id: r26090-20090629-1316
Edit : i've also added the .jar files in Talend lib directory !
thanks for your help
Last edited by kzone (2009-08-24 14:33:03)
Perhaps It could work if I import the jar file missing (jpscs.jar) in the JDBC code !
Where can i found source for metadata JDBC to try that way !?
For example if I add an import "import com.pervasive.pscs.Manager" (Class i'm loadind in tLibraryLoad) in " tJDBCConnection_begin.javajet"
I would be able to use shema editor !??
My goal is to be able to retrieve schemas and avoid to define them by hand (work fine if i do that but it's a long way ) and make a migration from btrieve to Sql database.
Last edited by kzone (2009-08-24 15:53:52)
i'm extending JDBC component to working with Pervasive Connection ..(I'll put new Component in the Talend exchange right "onreadystate"
but it shold be helpfully to be able to use metadata db connection ... !
Suggestion or help will be appreciate
Last edited by kzone (2009-08-26 12:00:33)
With very few modification in the JDBCColumnList (add a PERVASIVE name, ..etc)
, I can read the schema of a pervasive table "on the fly " ... what i'm looking for !
So resolved problem (but hope for some clue to do it with metadta )
have a look at exchange repository and look for
hope it could help you !
I'll have a look at this as soon as possible (hope today !)
I've downloaded component, unarchived in TOS/plugins/org.talend.designer.components.localprovider_xxx and copied .jar in TOS/lib/java repository and it looks like OK ! (try with TOS Version: 4.0.0M2
Build id: r35653-20100114-0503 )
Use you own repository (@see preferences=>Talend=>components=>path to you user component) if you don't want to share "native" and " imported" talend component !
ps :Are talking about "tPervasiveConnection_java.xml" ?
Last edited by kzone (2010-03-16 10:36:37)
Sorry, took me some time put my notebook to work ok and get the 4.0M3.
Anyway, i tried with the M3 in talend exchange, download the Pervasive components, but it gave me the same message.
Any clue about what is missing?
i've (re)done the extraction and I see what's wrong ! (i hope
When you extract Component pervasive connection you've got a repository (tPervasiveConnection_Component) and inside "lib" and "tPervasiveConnection" ....
It's tPervasiveConnection you have to copy in your Talend repository componenet and not tPervasiveConnection_Component ! (it's the reason why talend 's looking for tPervasiveConnection_Component_java.xml )
files "jar" are going into yourTalend/lib/java .
hope it's clear enought