Talend community forum / [resolved] Pervasive (Btrieve) Metadata Connection

kzone · 2009-08-24 14:18:41

Tags: [Btrieve, bug, error, java, pervasive, TOS3.1]

hi all

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.

env :
Talend Open Studio

Version: 3.1.3
Build id: r26090-20090629-1316

Edit : i've also added the .jar files in Talend lib directory !

thanks for your help
Regards
laurent

Uploaded Images

Last edited by kzone (2009-08-24 14:33:03)

kzone · 2009-08-24 15:27:28

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)

kzone · 2009-08-26 12:00:13

ok,

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

regards
laurent

Last edited by kzone (2009-08-26 12:00:33)

kzone · 2009-08-26 13:10:49

.....

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 )

Regards
laurent

Uploaded Images

TDK · 2010-03-08 15:06:40

Hello kzone.
I'm using Pervasive as well and got the same problem that you reported about connection. By a chance, have you posted your component?

Best regards

kzone · 2010-03-08 19:37:40

hi,

have a look at exchange repository and look for

tJDBCColumnList_extend
tPervasiveConnection
tPervasiveInput

hope it could help you !

laurent
++

TDK · 2010-03-12 19:02:54

Hi

kzone, I'm getting the same message when I download these components:
"Cannot find file"tPervasiveConnection_Component_java.xml" "
Have any thoughts of what can I do about this?

Thanks

kzone · 2010-03-15 09:39:32

hi,

and hooo

I'll have a look at this as soon as possible (hope today !)
laurent

EDIT
===

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)

TDK · 2010-03-22 13:22:18

Hi kzone
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?

Many thanks

kzone · 2010-03-22 17:09:07

ok ,

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

regards
laurent

Announcement

Unanswered posts

#1 2009-08-24 14:18:41

[resolved] Pervasive (Btrieve) Metadata Connection

#2 2009-08-24 15:27:28

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#3 2009-08-26 12:00:13

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#4 2009-08-26 13:10:49

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#5 2010-03-08 15:06:40

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#6 2010-03-08 19:37:40

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#7 2010-03-12 19:02:54

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#8 2010-03-15 09:39:32

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#9 2010-03-22 13:22:18

Re: [resolved] Pervasive (Btrieve) Metadata Connection

#10 2010-03-22 17:09:07

Re: [resolved] Pervasive (Btrieve) Metadata Connection

Board footer